Desktop Computer Skills
Microsoft Office for Mac 2016 - Excel
Microsoft Excel 2016 for Mac: Basic Formulas
Microsoft Excel 2016 for Mac: Charts and Graphs
Microsoft Excel 2016 for Mac: Configuring Excel
Microsoft Excel 2016 for Mac: Creating, Saving, and Sharing Workbooks
Microsoft Excel 2016 for Mac: Custom and Conditional Formatting
Microsoft Excel 2016 for Mac: Extracting Information with Formulas
Microsoft Excel 2016 for Mac: Finding, Sorting, and Filtering Data
Microsoft Excel 2016 for Mac: Formatting Data
Microsoft Excel 2016 for Mac: Illustrating Documents
Microsoft Excel 2016 for Mac: Opening and Setting Up
Microsoft Excel 2016 for Mac: PivotTables
Microsoft Excel 2016 for Mac: Referencing Data
Microsoft Excel 2016 for Mac: Working with Formulas

Microsoft Excel 2016 for Mac: Basic Formulas

Course Number:
ds_msex16mc_09_enus
Objectives:

Overview/Description

The Function Library in Excel contains a large number of ready-to-use formulas. Discover how to work with both basic formulas and conditional formulas to extract the values you need.



Target

Prerequisites: none

Microsoft Excel 2016 for Mac: Basic Formulas

Course Number:
ds_msex16mc_09_enus
Objectives:

Overview/Description

The Function Library in Excel contains a large number of ready-to-use formulas. Discover how to work with both basic formulas and conditional formulas to extract the values you need.



Target

Prerequisites: none

Microsoft Excel 2016 for Mac: Charts and Graphs

Course Number:
ds_msex16mc_11_enus
Objectives:

Overview/Description
Using charts is an effective way to present data in your Excel spreadsheet. Learn how to insert, format, and customize different chart types in Excel, and how to insert and work with trendlines.

Target

Prerequisites: none

Microsoft Excel 2016 for Mac: Charts and Graphs

Course Number:
ds_msex16mc_11_enus
Objectives:

Overview/Description
Using charts is an effective way to present data in your Excel spreadsheet. Learn how to insert, format, and customize different chart types in Excel, and how to insert and work with trendlines.

Target

Prerequisites: none

Microsoft Excel 2016 for Mac: Configuring Excel

Course Number:
ds_msex16mc_14_enus
Objectives:

Overview/Description
Excel 2016 for Mac is a highly customizable application. Learn how to customize the interface, view settings, input options, ribbon, and Quick Access toolbar, and how to install and manage add-ins.

Target

Prerequisites: none

Microsoft Excel 2016 for Mac: Configuring Excel

Course Number:
ds_msex16mc_14_enus
Objectives:

Overview/Description
Excel 2016 for Mac is a highly customizable application. Learn how to customize the interface, view settings, input options, ribbon, and Quick Access toolbar, and how to install and manage add-ins.

Target

Prerequisites: none

Microsoft Excel 2016 for Mac: Creating, Saving, and Sharing Workbooks

Course Number:
ds_msex16mc_02_enus
Objectives:

Overview/Description

There are numerous ways to set up a document in Excel. Discover how to create, save, print, and manage documents; edit document properties; work with the protection settings; and share documents via email and OneDrive.



Target

Prerequisites: none

Microsoft Excel 2016 for Mac: Creating, Saving, and Sharing Workbooks

Course Number:
ds_msex16mc_02_enus
Objectives:

Overview/Description

There are numerous ways to set up a document in Excel. Discover how to create, save, print, and manage documents; edit document properties; work with the protection settings; and share documents via email and OneDrive.



Target

Prerequisites: none

Microsoft Excel 2016 for Mac: Custom and Conditional Formatting

Course Number:
ds_msex16mc_05_enus
Objectives:

Overview/Description
In addition to the formats built into Excel, you can also use custom formats. Learn to create and use custom date, time, number, and text formats, and work with the conditional formatting tools in Excel.

Target

Prerequisites: none

Microsoft Excel 2016 for Mac: Custom and Conditional Formatting

Course Number:
ds_msex16mc_05_enus
Objectives:

Overview/Description
In addition to the formats built into Excel, you can also use custom formats. Learn to create and use custom date, time, number, and text formats, and work with the conditional formatting tools in Excel.

Target

Prerequisites: none

Microsoft Excel 2016 for Mac: Extracting Information with Formulas

Course Number:
ds_msex16mc_13_enus
Objectives:

Overview/Description

Excel includes a number of formulas for extracting information from data. Discover how to use a number of these formulas, including MAX, MIN, LARGE, SMALL, CONCAT, and VLOOKUP.



Target

Prerequisites: none

Microsoft Excel 2016 for Mac: Extracting Information with Formulas

Course Number:
ds_msex16mc_13_enus
Objectives:

Overview/Description

Excel includes a number of formulas for extracting information from data. Discover how to use a number of these formulas, including MAX, MIN, LARGE, SMALL, CONCAT, and VLOOKUP.



Target

Prerequisites: none

Microsoft Excel 2016 for Mac: Finding, Sorting, and Filtering Data

Course Number:
ds_msex16mc_07_enus
Objectives:

Overview/Description

In large spreadsheets, it is not always easy to locate the data you need. Discover the tools in Excel to find, replace, sort, and filter data. Also, learn how to create an outline, freeze panes, and hide duplicate values.



Target

Prerequisites: none

Microsoft Excel 2016 for Mac: Finding, Sorting, and Filtering Data

Course Number:
ds_msex16mc_07_enus
Objectives:

Overview/Description

In large spreadsheets, it is not always easy to locate the data you need. Discover the tools in Excel to find, replace, sort, and filter data. Also, learn how to create an outline, freeze panes, and hide duplicate values.



Target

Prerequisites: none

Microsoft Excel 2016 for Mac: Formatting Data

Course Number:
ds_msex16mc_04_enus
Objectives:

Overview/Description
You can make your data more meaningful by changing its appearance in the spreadsheet. Learn how to set the data type, format your data using colors and themes, work with tables and titles, and insert borders in your Excel spreadsheet.

Target

Prerequisites: none

Microsoft Excel 2016 for Mac: Formatting Data

Course Number:
ds_msex16mc_04_enus
Objectives:

Overview/Description
You can make your data more meaningful by changing its appearance in the spreadsheet. Learn how to set the data type, format your data using colors and themes, work with tables and titles, and insert borders in your Excel spreadsheet.

Target

Prerequisites: none

Microsoft Excel 2016 for Mac: Illustrating Documents

Course Number:
ds_msex16mc_06_enus
Objectives:

Overview/Description

There are numerous elements you can add to improve the appearance of your Excel documents. Discover how to work with images, photos, screenshots, shapes, and diagrams; insert a hyperlink; and use the Smart Lookup tool.



Target

Prerequisites: none

Microsoft Excel 2016 for Mac: Illustrating Documents

Course Number:
ds_msex16mc_06_enus
Objectives:

Overview/Description

There are numerous elements you can add to improve the appearance of your Excel documents. Discover how to work with images, photos, screenshots, shapes, and diagrams; insert a hyperlink; and use the Smart Lookup tool.



Target

Prerequisites: none

Microsoft Excel 2016 for Mac: Opening and Setting Up Excel

Course Number:
ds_msex16mc_01_enus
Objectives:

Overview/Description

Get started with Excel 2016 for Mac, and explore the interface. Discover tools, the zoom function, view modes, and how to navigate between multiple documents.



Target

Prerequisites: none

Microsoft Excel 2016 for Mac: Opening and Setting Up Excel

Course Number:
ds_msex16mc_01_enus
Objectives:

Overview/Description

Get started with Excel 2016 for Mac, and explore the interface. Discover tools, the zoom function, view modes, and how to navigate between multiple documents.



Target

Prerequisites: none

Microsoft Excel 2016 for Mac: PivotTables

Course Number:
ds_msex16mc_12_enus
Objectives:

Overview/Description
A PivotTable is one of the most powerful and intimidating features in Excel. Learn how to get the most out of a PivotTable to help you summarize and extract information from your data.

Target

Prerequisites: none

Microsoft Excel 2016 for Mac: PivotTables

Course Number:
ds_msex16mc_12_enus
Objectives:

Overview/Description
A PivotTable is one of the most powerful and intimidating features in Excel. Learn how to get the most out of a PivotTable to help you summarize and extract information from your data.

Target

Prerequisites: none

Microsoft Excel 2016 for Mac: Referencing Data

Course Number:
ds_msex16mc_08_enus
Objectives:

Overview/Description

To use the contents of a cell, you must know how to reference that cell. Explore absolute and relative cell referencing, and discover how to work with named data ranges, formula auditing tools, and formula error messages in Excel.



Target

Prerequisites: none

Microsoft Excel 2016 for Mac: Referencing Data

Course Number:
ds_msex16mc_08_enus
Objectives:

Overview/Description

To use the contents of a cell, you must know how to reference that cell. Explore absolute and relative cell referencing, and discover how to work with named data ranges, formula auditing tools, and formula error messages in Excel.



Target

Prerequisites: none

Microsoft Excel 2016 for Mac: Working with Formulas

Course Number:
ds_msex16mc_10_enus
Objectives:

Overview/Description

Excel includes tools and formulas for solving more advanced problems. Discover how to calculate loan interest, use the Goal Seek and Solver tools, and handle duplicate values in your spreadsheet.



Target

Prerequisites: none

Microsoft Excel 2016 for Mac: Working with Formulas

Course Number:
ds_msex16mc_10_enus
Objectives:

Overview/Description

Excel includes tools and formulas for solving more advanced problems. Discover how to calculate loan interest, use the Goal Seek and Solver tools, and handle duplicate values in your spreadsheet.



Target

Prerequisites: none

Close Chat Live